Mega Code Archive
Database Functions
1) Database functions
2) DCOUNT(database,field,criteria) counts the cells that contain numbers in a database
3) DCOUNTA(database,field,criteria) counts nonblank cells in a database
4) DGET(database,field,criteria) extracts from a database a single record that matches the specified criteria
5) DMAX(database,field,criteria) returns the maximum value from selected database entries
6) DMIN(database,field,criteria) returns the minimum value from selected database entries
7) DPRODUCT(database,field,criteria) multiplies the values that match the criteria in a database
8) DSTDEV(database,field,criteria) estimates the standard deviation based on selected database entries
9) DSTDEVP(database,field,criteria) calculates the standard deviation
10) DSUM(database,field,criteria) adds the numbers in the database
11) DVAR(database,field,criteria) estimates variance based on a sample from selected database entries
12) DVARP(database,field,criteria) calculates variance based on the selected database entries
13) Use greater than
14) Use the equals sign ==entry
15) Use the equals sign with text
16) Use the equals sign with value
17) Use wild card character